<?php
die;
/*
 * Created on 2012-8-30
====================
@liupeng-新加资源
好友邀请模板-friends
回收站-trash
====================
回收站开发说明@liupeng
1 控制器中delete方法中的
		delete改为hide

2  model添加主键属性$this->_tableKey = 'game_id';
3. model添加 trash方法,做记录说明

	//$row是此条数据
    //回收信息的描述
    public function trash($row){
    	$rs='';
    	$rs.='删除了游戏:'.$row['name'];//name 是 中文名称-对应字段,根据实际情况写
        return $rs;
    }
================================
ALTER TABLE  `user` ADD  `fisdel` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0';
ALTER TABLE  `g5_article` ADD  `fisdel` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0';
ALTER TABLE  `g5_article_type` ADD  `fisdel` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0';
ALTER TABLE  `g5_ads` ADD  `fisdel` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0';
=====2012-09-06====
tongji_game 	index|user
tongji_log 		index

=====2012-09-11===
成就game_achieve  index|add|edit|delete

-- sql
CREATE TABLE IF NOT EXISTS `game_achieve` (
  `achieve_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '成就自增id',
  `name` varchar(255) NOT NULL,
  `name_en` char(255) NOT NULL,
  `name_jp` char(255) NOT NULL,
  `name_ko` char(255) NOT NULL,
  `name_tw` char(255) NOT NULL,
  `desc` char(255) NOT NULL COMMENT '描述',
  `desc_en` char(255) NOT NULL,
  `desc_jp` char(255) NOT NULL,
  `desc_ko` char(255) NOT NULL,
  `desc_tw` char(255) NOT NULL,
  `game_id` smallint(6) NOT NULL,
  `create_time` int(10) NOT NULL,
  `achieve_order` tinyint(4) NOT NULL COMMENT '排序',
  PRIMARY KEY (`achieve_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='成就' AUTO_INCREMENT=1 ;



 ALTER TABLE  `g5_game`
 ADD  `fplatform_ios` TINYINT NOT NULL DEFAULT  '0' COMMENT  'ios平台上线'         AFTER  `fplatform` ,
 ADD  `fplatform_android` TINYINT NOT NULL DEFAULT  '0' COMMENT  'android平台上线' AFTER  `fplatform_ios`,
 ADD  `fplatform_html5` tinyint NOT NULL DEFAULT '0' COMMENT 'html5平台上线'       AFTER  `fplatform_android`,
 ADD  `fplatform_all` tinyint NOT NULL DEFAULT '0' COMMENT '全部平台上线'          AFTER  `fplatform_html5`

 ALTER TABLE  `g5_game`
 ADD  `online_appstore` TINYINT NOT NULL DEFAULT  '0' COMMENT  'app store上线'         AFTER  `online_app` ,
 ADD  `online_91` TINYINT NOT NULL DEFAULT  '0' COMMENT  '91助手上线'         AFTER  `online_appstore` ,
 ADD  `online_adsage` TINYINT NOT NULL DEFAULT  '0' COMMENT  'adsage上线'         AFTER  `online_91` ,
 ADD  `online_admob` TINYINT NOT NULL DEFAULT  '0' COMMENT  'admob上线'         AFTER  `online_adsage` ,
 ADD  `online_limei` TINYINT NOT NULL DEFAULT  '0' COMMENT  '力美上线'         AFTER  `online_admob` ,
 ADD  `online_jiashi` TINYINT NOT NULL DEFAULT  '0' COMMENT  '架势上线'         AFTER  `online_limei` ,
 ADD  `online_duomeng` TINYINT NOT NULL DEFAULT  '0' COMMENT  '多盟上线'         AFTER  `online_jiashi` ,
 ADD  `online_youmeng` TINYINT NOT NULL DEFAULT  '0' COMMENT  '友盟上线'         AFTER  `online_duomeng` ,
 ADD  `online_huawei` TINYINT NOT NULL DEFAULT  '0' COMMENT  '华为网盘上线'         AFTER  `online_youmeng` ,
 ADD  `online_tongbu` TINYINT NOT NULL DEFAULT  '0' COMMENT  '同步助手上线'         AFTER  `online_huawei` ,
 ADD  `online_pp` TINYINT NOT NULL DEFAULT  '0' COMMENT  'pp助手上线'         AFTER  `online_tongbu`



 ALTER TABLE  `game_product`
 ADD `currency` enum('rmb','usd') NOT NULL COMMENT '货币 usd美元,rmb人民币' AFTER  `product_price`;


//多平台游戏区分 2012.12.03
 ALTER TABLE  `game_achieve`    ADD  COLUMN  `platform` ENUM(  'ios',  'android' ) NOT NULL DEFAULT  'ios' COMMENT  '平台' AFTER  `name`;












 */
?>
